package cloud.pojo;

import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.sql.Timestamp;

@Data
@Entity
@Table(name="tb_orders")
public class Orders {
    @Id
    @Column(name = "id",length = 20)
    private String id;//订单ID

    @Column(name = "userid")
    private String userid;//客户ID

    @Column(name = "shopid")
    private String shopid;//商品ID

    @Column(name = "shoptype")
    private String shoptype;//商品类型 0是视频1考试

    @Column(name = "creattime")
    private Timestamp creattime;//订单创建时间

    @Column(name = "endtime")
    private Timestamp endtime;//订单结算时间

    @Column(name = "orderpayment",length = 2)
    private String orderpayment;//支付状态(1:未付款,2:已付款)

    @Column(name = "orderstate",length = 2)
    private String orderstate;//订单状态(1:未处理,2:已处理)

    @Column(name = "orderremarks")
    private String orderremarks;//订单备注

    @Column(name = "orderprice")
    private Double orderprice;//商品总金额



}
